Release 10.1A: OpenEdge Getting Started:
Database Essentials
Deactivating indexes
Indexes that you seldom use can impair performance by causing unnecessary overhead. If you do not want to delete a seldom-used index, then deactivate it. Deactivating an index eliminates the processing overhead associated with the index, but does not free up its disk space. For information on how to deactivate indexes, see OpenEdge Data Management: Database Administration . To learn how to do this using SQL, see OpenEdge Data Management: SQL Reference .
|
Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |